﻿using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using System.Collections.Generic;
using System;
namespace WPFExcelReport
{
    public partial class VGSDAT
    {
        public readonly static VGSDAT Instance = new VGSDAT();
        private string _CART=""; public string CART { get { return _CART; } set { _CART = value; OnPropertyChanged("CART", value); } }
        public VGSCOLOR VGSC
        {
            get
            {
                if (!ENVMAIN.ContainsKey("VGSC"))
                    ENVMAIN["VGSC"] = new VGSCOLOR();
                return (VGSCOLOR)ENVMAIN["VGSC"];
            }
        }
        public VGASTGA VGS08
        {
            get
            {
                if (!ENVMAIN.ContainsKey("VGS08"))
                    ENVMAIN["VGS08"] = new VGASTGA();
                return (VGASTGA)ENVMAIN["VGS08"];
            }
        }

        VGSMATK GM;
        private bool _FTGS04;
        public bool FTGS04
        {
            get { return _FTGS04; }
            set { _FTGS04 = value; OnPropertyChanged("FTGS04", value); }
        }
        public DataSet LOAD(Dictionary<string, object> pm)
        {
            TBMain.Clear();
            string art = (string)pm["CART"];
            if (art.Length < 23)
                return null;
            dwData = TBMain.NewRow();
            dwData["GSMANDANT"] = app.Mandant;
            dwData["GSART"] = Helpers.Helper.Left(art, 20);
            dwData["GSVAR"] = art.Substring(20, 3);
            SResult = QGS01(dwData);
            MergeData(SResult, true);
            return SResult;
        }


    }
    public partial class VGSDAT
    {
        public string GSART { get { if (dwMaster == null) return ""; return dwMaster["GSART"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSART"] = value; OnPropertyChanged("GSART", value); } } //lENGth 20
        public string GSGARNNR { get { if (dwMaster == null) return ""; return dwMaster["GSGARNNR"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSGARNNR"] = value; OnPropertyChanged("GSGARNNR", value); } } //lENGth 0
        public string GSFACH { get { if (dwMaster == null) return ""; return dwMaster["GSFACH"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSFACH"] = value; OnPropertyChanged("GSFACH", value); } } //lENGth 3
        public string GSHANDLNR { get { if (dwMaster == null) return ""; return dwMaster["GSHANDLNR"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSHANDLNR"] = value; OnPropertyChanged("GSHANDLNR", value); } } //lENGth 60
        public string GSVAR { get { if (dwMaster == null) return ""; return dwMaster["GSVAR"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSVAR"] = value; OnPropertyChanged("GSVAR", value); } } //lENGth 3
        public string GSAENDBEN { get { if (dwMaster == null) return ""; return dwMaster["GSAENDBEN"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSAENDBEN"] = value; OnPropertyChanged("GSAENDBEN", value); } } //lENGth 8
        public double GSAENDDAT { get { if (dwMaster == null) return 0.0; return Convert.ToDouble(dwMaster["GSAENDDAT"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSAENDDAT"] = value; OnPropertyChanged("GSAENDDAT", value); } } //lENGth 0
        public string GSNEUBEN { get { if (dwMaster == null) return ""; return dwMaster["GSNEUBEN"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSNEUBEN"] = value; OnPropertyChanged("GSNEUBEN", value); } } //lENGth 8
        public double GSNEUDAT { get { if (dwMaster == null) return 0.0; return Convert.ToDouble(dwMaster["GSNEUDAT"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSNEUDAT"] = value; OnPropertyChanged("GSNEUDAT", value); } } //lENGth 0
        public string GSNUMART { get { if (dwMaster == null) return ""; return dwMaster["GSNUMART"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSNUMART"] = value; OnPropertyChanged("GSNUMART", value); } } //lENGth 4
        public string GSRECHNUM { get { if (dwMaster == null) return ""; return dwMaster["GSRECHNUM"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSRECHNUM"] = value; OnPropertyChanged("GSRECHNUM", value); } } //lENGth 4
        public double GSRECHNR { get { if (dwMaster == null) return 0.0; return Convert.ToDouble(dwMaster["GSRECHNR"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSRECHNR"] = value; OnPropertyChanged("GSRECHNR", value); } } //lENGth 0
        public string GSFERTKZ { get { if (dwMaster == null) return ""; return dwMaster["GSFERTKZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSFERTKZ"] = value; OnPropertyChanged("GSFERTKZ", value); } } //lENGth 1
        public double GSBWPR1 { get { if (dwMaster == null) return 0.0; return Convert.ToDouble(dwMaster["GSBWPR1"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSBWPR1"] = value; OnPropertyChanged("GSBWPR1", value); } } //lENGth 0
        public double GSBWPR2 { get { if (dwMaster == null) return 0.0; return Convert.ToDouble(dwMaster["GSBWPR2"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSBWPR2"] = value; OnPropertyChanged("GSBWPR2", value); } } //lENGth 0
        public double GSBWPR3 { get { if (dwMaster == null) return 0.0; return Convert.ToDouble(dwMaster["GSBWPR3"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSBWPR3"] = value; OnPropertyChanged("GSBWPR3", value); } } //lENGth 0

        #region======ColumnSchema==========
        /*
                 public string GSMANDANT { get { if (dwMaster == null) return ""; return dwMaster["GSMANDANT"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSMANDANT"] = value; OnPropertyChanged("GSMANDANT", value); } } //lENGth 2
                  public double GSAENDZL { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSAENDZL"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSAENDZL"] = value; OnPropertyChanged("GSAENDZL", value); } } //lENGth 0
                 public string GSMTART { get { if (dwMaster == null) return ""; return dwMaster["GSMTART"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSMTART"] = value; OnPropertyChanged("GSMTART", value); } } //lENGth 4
                 public string GSSTAKZ { get { if (dwMaster == null) return ""; return dwMaster["GSSTAKZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSSTAKZ"] = value; OnPropertyChanged("GSSTAKZ", value); } } //lENGth 1
                 public string GSKUNDNR { get { if (dwMaster == null) return ""; return dwMaster["GSKUNDNR"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSKUNDNR"] = value; OnPropertyChanged("GSKUNDNR", value); } } //lENGth 8
                 public string GSSTVAR { get { if (dwMaster == null) return ""; return dwMaster["GSSTVAR"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSSTVAR"] = value; OnPropertyChanged("GSSTVAR", value); } } //lENGth 1
                 public string GSGSART { get { if (dwMaster == null) return ""; return dwMaster["GSGSART"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSGSART"] = value; OnPropertyChanged("GSGSART", value); } } //lENGth 3
                 public string GSPROF { get { if (dwMaster == null) return ""; return dwMaster["GSPROF"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSPROF"] = value; OnPropertyChanged("GSPROF", value); } } //lENGth 1
                 public string GSMUSTERKZ { get { if (dwMaster == null) return ""; return dwMaster["GSMUSTERKZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSMUSTERKZ"] = value; OnPropertyChanged("GSMUSTERKZ", value); } } //lENGth 1
                 public string GSMURLOD { get { if (dwMaster == null) return ""; return dwMaster["GSMURLOD"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSMURLOD"] = value; OnPropertyChanged("GSMURLOD", value); } } //lENGth 2
                 public string GSMUPROD { get { if (dwMaster == null) return ""; return dwMaster["GSMUPROD"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSMUPROD"] = value; OnPropertyChanged("GSMUPROD", value); } } //lENGth 2
                 public string GSMUCTOD { get { if (dwMaster == null) return ""; return dwMaster["GSMUCTOD"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSMUCTOD"] = value; OnPropertyChanged("GSMUCTOD", value); } } //lENGth 1
                 public double GSMUDTRL { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSMUDTRL"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSMUDTRL"] = value; OnPropertyChanged("GSMUDTRL", value); } } //lENGth 0
                 public string GSMUBIRL { get { if (dwMaster == null) return ""; return dwMaster["GSMUBIRL"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSMUBIRL"] = value; OnPropertyChanged("GSMUBIRL", value); } } //lENGth 8
                 public string GSCOLORED { get { if (dwMaster == null) return ""; return dwMaster["GSCOLORED"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCOLORED"] = value; OnPropertyChanged("GSCOLORED", value); } } //lENGth 1
                 public string GSHANDLNR { get { if (dwMaster == null) return ""; return dwMaster["GSHANDLNR"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSHANDLNR"] = value; OnPropertyChanged("GSHANDLNR", value); } } //lENGth 60
                 public string GSGARNBEZ { get { if (dwMaster == null) return ""; return dwMaster["GSGARNBEZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSGARNBEZ"] = value; OnPropertyChanged("GSGARNBEZ", value); } } //lENGth 40
                 public string GSAGARNNR { get { if (dwMaster == null) return ""; return dwMaster["GSAGARNNR"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSAGARNNR"] = value; OnPropertyChanged("GSAGARNNR", value); } } //lENGth 15
                 public string GSTYP { get { if (dwMaster == null) return ""; return dwMaster["GSTYP"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSTYP"] = value; OnPropertyChanged("GSTYP", value); } } //lENGth 3
                 public string GSMAT { get { if (dwMaster == null) return ""; return dwMaster["GSMAT"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSMAT"] = value; OnPropertyChanged("GSMAT", value); } } //lENGth 6
                 public double GSGARNNR { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSGARNNR"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSGARNNR"] = value; OnPropertyChanged("GSGARNNR", value); } } //lENGth 0
                 public string GSFACH { get { if (dwMaster == null) return ""; return dwMaster["GSFACH"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSFACH"] = value; OnPropertyChanged("GSFACH", value); } } //lENGth 3
                 public double GSREPRISE { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSREPRISE"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSREPRISE"] = value; OnPropertyChanged("GSREPRISE", value); } } //lENGth 0
                 public double GSIFEUCHTE { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSIFEUCHTE"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSIFEUCHTE"] = value; OnPropertyChanged("GSIFEUCHTE", value); } } //lENGth 0
                 public double GSIFEUVTR { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSIFEUVTR"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSIFEUVTR"] = value; OnPropertyChanged("GSIFEUVTR", value); } } //lENGth 0
                 public double GSKAPIL { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSKAPIL"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSKAPIL"] = value; OnPropertyChanged("GSKAPIL", value); } } //lENGth 0
                 public double GSKAPILLG { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSKAPILLG"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSKAPILLG"] = value; OnPropertyChanged("GSKAPILLG", value); } } //lENGth 0
                 public double GSTOME { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSTOME"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSTOME"] = value; OnPropertyChanged("GSTOME", value); } } //lENGth 0
                 public string GSDREH { get { if (dwMaster == null) return ""; return dwMaster["GSDREH"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSDREH"] = value; OnPropertyChanged("GSDREH", value); } } //lENGth 1
                 public double GSTOMEVOR { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSTOMEVOR"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSTOMEVOR"] = value; OnPropertyChanged("GSTOMEVOR", value); } } //lENGth 0
                 public string GSDREHVOR { get { if (dwMaster == null) return ""; return dwMaster["GSDREHVOR"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSDREHVOR"] = value; OnPropertyChanged("GSDREHVOR", value); } } //lENGth 1
                 public double GSDREHWI { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSDREHWI"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSDREHWI"] = value; OnPropertyChanged("GSDREHWI", value); } } //lENGth 0
                 public string GSSURFACE { get { if (dwMaster == null) return ""; return dwMaster["GSSURFACE"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSSURFACE"] = value; OnPropertyChanged("GSSURFACE", value); } } //lENGth 1
                 public string GSKZGM { get { if (dwMaster == null) return ""; return dwMaster["GSKZGM"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSKZGM"] = value; OnPropertyChanged("GSKZGM", value); } } //lENGth 1
                 public string GSCROSSEC { get { if (dwMaster == null) return ""; return dwMaster["GSCROSSEC"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCROSSEC"] = value; OnPropertyChanged("GSCROSSEC", value); } } //lENGth 1
                 public string GSTEXTUR { get { if (dwMaster == null) return ""; return dwMaster["GSTEXTUR"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSTEXTUR"] = value; OnPropertyChanged("GSTEXTUR", value); } } //lENGth 1
                 public string GSEFFEKT { get { if (dwMaster == null) return ""; return dwMaster["GSEFFEKT"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSEFFEKT"] = value; OnPropertyChanged("GSEFFEKT", value); } } //lENGth 3
                 public double GSEFFEKTLG { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSEFFEKTLG"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSEFFEKTLG"] = value; OnPropertyChanged("GSEFFEKTLG", value); } } //lENGth 0
                 public double GSEFFEKTDM { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSEFFEKTDM"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSEFFEKTDM"] = value; OnPropertyChanged("GSEFFEKTDM", value); } } //lENGth 0
                 public string GSTREATM1 { get { if (dwMaster == null) return ""; return dwMaster["GSTREATM1"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSTREATM1"] = value; OnPropertyChanged("GSTREATM1", value); } } //lENGth 3
                 public string GSTREATM2 { get { if (dwMaster == null) return ""; return dwMaster["GSTREATM2"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSTREATM2"] = value; OnPropertyChanged("GSTREATM2", value); } } //lENGth 3
                 public string GSWAX { get { if (dwMaster == null) return ""; return dwMaster["GSWAX"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSWAX"] = value; OnPropertyChanged("GSWAX", value); } } //lENGth 1
                 public string GSUSE { get { if (dwMaster == null) return ""; return dwMaster["GSUSE"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSUSE"] = value; OnPropertyChanged("GSUSE", value); } } //lENGth 3
                 public string GSFIBPREP { get { if (dwMaster == null) return ""; return dwMaster["GSFIBPREP"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSFIBPREP"] = value; OnPropertyChanged("GSFIBPREP", value); } } //lENGth 1
                 public string GSSPINPRO { get { if (dwMaster == null) return ""; return dwMaster["GSSPINPRO"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSSPINPRO"] = value; OnPropertyChanged("GSSPINPRO", value); } } //lENGth 3
                 public string GSPRODPRO { get { if (dwMaster == null) return ""; return dwMaster["GSPRODPRO"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSPRODPRO"] = value; OnPropertyChanged("GSPRODPRO", value); } } //lENGth 3
                 public string GSPROGRP { get { if (dwMaster == null) return ""; return dwMaster["GSPROGRP"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSPROGRP"] = value; OnPropertyChanged("GSPROGRP", value); } } //lENGth 3
                 public string GSARTGRP { get { if (dwMaster == null) return ""; return dwMaster["GSARTGRP"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSARTGRP"] = value; OnPropertyChanged("GSARTGRP", value); } } //lENGth 3
                 public string GSTAX { get { if (dwMaster == null) return ""; return dwMaster["GSTAX"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSTAX"] = value; OnPropertyChanged("GSTAX", value); } } //lENGth 3
                 public string GSGRADE { get { if (dwMaster == null) return ""; return dwMaster["GSGRADE"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSGRADE"] = value; OnPropertyChanged("GSGRADE", value); } } //lENGth 2
                 public string GSCLASS { get { if (dwMaster == null) return ""; return dwMaster["GSCLASS"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCLASS"] = value; OnPropertyChanged("GSCLASS", value); } } //lENGth 2
                 public string GSFORTE { get { if (dwMaster == null) return ""; return dwMaster["GSFORTE"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSFORTE"] = value; OnPropertyChanged("GSFORTE", value); } } //lENGth 2
                 public string GSAUFMSL { get { if (dwMaster == null) return ""; return dwMaster["GSAUFMSL"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSAUFMSL"] = value; OnPropertyChanged("GSAUFMSL", value); } } //lENGth 2
                 public double GSDURSP { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSDURSP"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSDURSP"] = value; OnPropertyChanged("GSDURSP", value); } } //lENGth 0
                 public double GSKG { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSKG"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSKG"] = value; OnPropertyChanged("GSKG", value); } } //lENGth 0
                 public double GSKGBIS { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSKGBIS"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSKGBIS"] = value; OnPropertyChanged("GSKGBIS", value); } } //lENGth 0
                 public string GSFDRES { get { if (dwMaster == null) return ""; return dwMaster["GSFDRES"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSFDRES"] = value; OnPropertyChanged("GSFDRES", value); } } //lENGth 1
                 public string GSHUELSE { get { if (dwMaster == null) return ""; return dwMaster["GSHUELSE"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSHUELSE"] = value; OnPropertyChanged("GSHUELSE", value); } } //lENGth 6
                 public string GSCOLVAR { get { if (dwMaster == null) return ""; return dwMaster["GSCOLVAR"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCOLVAR"] = value; OnPropertyChanged("GSCOLVAR", value); } } //lENGth 3
                 public string GSCOLPT { get { if (dwMaster == null) return ""; return dwMaster["GSCOLPT"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCOLPT"] = value; OnPropertyChanged("GSCOLPT", value); } } //lENGth 1
                 public string GSHERLD { get { if (dwMaster == null) return ""; return dwMaster["GSHERLD"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSHERLD"] = value; OnPropertyChanged("GSHERLD", value); } } //lENGth 2
                 public string GSSAISON { get { if (dwMaster == null) return ""; return dwMaster["GSSAISON"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSSAISON"] = value; OnPropertyChanged("GSSAISON", value); } } //lENGth 2
                 public string GSSTASCHL { get { if (dwMaster == null) return ""; return dwMaster["GSSTASCHL"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSSTASCHL"] = value; OnPropertyChanged("GSSTASCHL", value); } } //lENGth 10
                 public string GSSTASL { get { if (dwMaster == null) return ""; return dwMaster["GSSTASL"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSSTASL"] = value; OnPropertyChanged("GSSTASL", value); } } //lENGth 10
                 public string GSSTASL3 { get { if (dwMaster == null) return ""; return dwMaster["GSSTASL3"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSSTASL3"] = value; OnPropertyChanged("GSSTASL3", value); } } //lENGth 10
                 public string GSBON { get { if (dwMaster == null) return ""; return dwMaster["GSBON"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSBON"] = value; OnPropertyChanged("GSBON", value); } } //lENGth 1
                 public string GSPMGRP { get { if (dwMaster == null) return ""; return dwMaster["GSPMGRP"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSPMGRP"] = value; OnPropertyChanged("GSPMGRP", value); } } //lENGth 4
                 public string GSSPINNA { get { if (dwMaster == null) return ""; return dwMaster["GSSPINNA"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSSPINNA"] = value; OnPropertyChanged("GSSPINNA", value); } } //lENGth 3
                 public double GSTEXEF { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSTEXEF"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSTEXEF"] = value; OnPropertyChanged("GSTEXEF", value); } } //lENGth 0
                 public double GSMICRON { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSMICRON"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSMICRON"] = value; OnPropertyChanged("GSMICRON", value); } } //lENGth 0
                 public double GSMICRONCV { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSMICRONCV"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSMICRONCV"] = value; OnPropertyChanged("GSMICRONCV", value); } } //lENGth 0
                 public double GSFIBL { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSFIBL"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSFIBL"] = value; OnPropertyChanged("GSFIBL", value); } } //lENGth 0
                 public double GSFIBLCV { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSFIBLCV"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSFIBLCV"] = value; OnPropertyChanged("GSFIBLCV", value); } } //lENGth 0
                 public double GSFIBLMA { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSFIBLMA"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSFIBLMA"] = value; OnPropertyChanged("GSFIBLMA", value); } } //lENGth 0
                 public double GSFIBDM { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSFIBDM"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSFIBDM"] = value; OnPropertyChanged("GSFIBDM", value); } } //lENGth 0
                 public double GSFIBL30 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSFIBL30"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSFIBL30"] = value; OnPropertyChanged("GSFIBL30", value); } } //lENGth 0
                 public double GSFIBL40 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSFIBL40"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSFIBL40"] = value; OnPropertyChanged("GSFIBL40", value); } } //lENGth 0
                 public double GSDRKFIBL { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSDRKFIBL"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSDRKFIBL"] = value; OnPropertyChanged("GSDRKFIBL", value); } } //lENGth 0
                 public double GSDRKFIBM { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSDRKFIBM"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSDRKFIBM"] = value; OnPropertyChanged("GSDRKFIBM", value); } } //lENGth 0
                 public double GSDRKFIBD { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSDRKFIBD"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSDRKFIBD"] = value; OnPropertyChanged("GSDRKFIBD", value); } } //lENGth 0
                 public double GSPRESSLEY { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSPRESSLEY"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSPRESSLEY"] = value; OnPropertyChanged("GSPRESSLEY", value); } } //lENGth 0
                 public double GSAVIV { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSAVIV"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSAVIV"] = value; OnPropertyChanged("GSAVIV", value); } } //lENGth 0
                 public double GSSCIG { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSSCIG"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSSCIG"] = value; OnPropertyChanged("GSSCIG", value); } } //lENGth 0
                 public double GSSCIGMA { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSSCIGMA"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSSCIGMA"] = value; OnPropertyChanged("GSSCIGMA", value); } } //lENGth 0
                 public double GSSCIGAV { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSSCIGAV"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSSCIGAV"] = value; OnPropertyChanged("GSSCIGAV", value); } } //lENGth 0
                 public double GSCNTEX { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSCNTEX"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSCNTEX"] = value; OnPropertyChanged("GSCNTEX", value); } } //lENGth 0
                 public string GSUV { get { if (dwMaster == null) return ""; return dwMaster["GSUV"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSUV"] = value; OnPropertyChanged("GSUV", value); } } //lENGth 2
                 public string GSESACHB { get { if (dwMaster == null) return ""; return dwMaster["GSESACHB"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSESACHB"] = value; OnPropertyChanged("GSESACHB", value); } } //lENGth 8
                 public string GSCADKEY { get { if (dwMaster == null) return ""; return dwMaster["GSCADKEY"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCADKEY"] = value; OnPropertyChanged("GSCADKEY", value); } } //lENGth 30
                 public string GSFAERBB { get { if (dwMaster == null) return ""; return dwMaster["GSFAERBB"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSFAERBB"] = value; OnPropertyChanged("GSFAERBB", value); } } //lENGth 1
                 public string GSWEISGB { get { if (dwMaster == null) return ""; return dwMaster["GSWEISGB"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSWEISGB"] = value; OnPropertyChanged("GSWEISGB", value); } } //lENGth 1
                 public string GSIONIZITAET { get { if (dwMaster == null) return ""; return dwMaster["GSIONIZITAET"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSIONIZITAET"] = value; OnPropertyChanged("GSIONIZITAET", value); } } //lENGth 1
                 public string GSAFFINITY { get { if (dwMaster == null) return ""; return dwMaster["GSAFFINITY"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSAFFINITY"] = value; OnPropertyChanged("GSAFFINITY", value); } } //lENGth 15
                 public string GSSUBST1 { get { if (dwMaster == null) return ""; return dwMaster["GSSUBST1"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSSUBST1"] = value; OnPropertyChanged("GSSUBST1", value); } } //lENGth 2
                 public string GSSUBST2 { get { if (dwMaster == null) return ""; return dwMaster["GSSUBST2"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSSUBST2"] = value; OnPropertyChanged("GSSUBST2", value); } } //lENGth 2
                 public string GSBLEACHED { get { if (dwMaster == null) return ""; return dwMaster["GSBLEACHED"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSBLEACHED"] = value; OnPropertyChanged("GSBLEACHED", value); } } //lENGth 1
                 public string GSCLORINEST { get { if (dwMaster == null) return ""; return dwMaster["GSCLORINEST"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCLORINEST"] = value; OnPropertyChanged("GSCLORINEST", value); } } //lENGth 1
                 public double GSFIXTEMP { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSFIXTEMP"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSFIXTEMP"] = value; OnPropertyChanged("GSFIXTEMP", value); } } //lENGth 0
                 public string GSFBTXT1 { get { if (dwMaster == null) return ""; return dwMaster["GSFBTXT1"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSFBTXT1"] = value; OnPropertyChanged("GSFBTXT1", value); } } //lENGth 4
                 public string GSFBTXT2 { get { if (dwMaster == null) return ""; return dwMaster["GSFBTXT2"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSFBTXT2"] = value; OnPropertyChanged("GSFBTXT2", value); } } //lENGth 4
                 public string GSFBTXT3 { get { if (dwMaster == null) return ""; return dwMaster["GSFBTXT3"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSFBTXT3"] = value; OnPropertyChanged("GSFBTXT3", value); } } //lENGth 4
                 public string GSFBTXT4 { get { if (dwMaster == null) return ""; return dwMaster["GSFBTXT4"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSFBTXT4"] = value; OnPropertyChanged("GSFBTXT4", value); } } //lENGth 4
                 public string GSFBTXT5 { get { if (dwMaster == null) return ""; return dwMaster["GSFBTXT5"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSFBTXT5"] = value; OnPropertyChanged("GSFBTXT5", value); } } //lENGth 4
                 public string GSSUBSTGR { get { if (dwMaster == null) return ""; return dwMaster["GSSUBSTGR"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSSUBSTGR"] = value; OnPropertyChanged("GSSUBSTGR", value); } } //lENGth 3
                 public string GSFALTEMP { get { if (dwMaster == null) return ""; return dwMaster["GSFALTEMP"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSFALTEMP"] = value; OnPropertyChanged("GSFALTEMP", value); } } //lENGth 3
                 public string GSKAKZ { get { if (dwMaster == null) return ""; return dwMaster["GSKAKZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSKAKZ"] = value; OnPropertyChanged("GSKAKZ", value); } } //lENGth 1
                 public string GSKARTZU { get { if (dwMaster == null) return ""; return dwMaster["GSKARTZU"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSKARTZU"] = value; OnPropertyChanged("GSKARTZU", value); } } //lENGth 1
                 public string GSSPULBST { get { if (dwMaster == null) return ""; return dwMaster["GSSPULBST"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSSPULBST"] = value; OnPropertyChanged("GSSPULBST", value); } } //lENGth 1
                 public string GSPFVARN { get { if (dwMaster == null) return ""; return dwMaster["GSPFVARN"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSPFVARN"] = value; OnPropertyChanged("GSPFVARN", value); } } //lENGth 1
                 public string GSPRUEFANW { get { if (dwMaster == null) return ""; return dwMaster["GSPRUEFANW"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSPRUEFANW"] = value; OnPropertyChanged("GSPRUEFANW", value); } } //lENGth 1
                 public string GSPRUEF { get { if (dwMaster == null) return ""; return dwMaster["GSPRUEF"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSPRUEF"] = value; OnPropertyChanged("GSPRUEF", value); } } //lENGth 4
                 public string GSFKART { get { if (dwMaster == null) return ""; return dwMaster["GSFKART"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSFKART"] = value; OnPropertyChanged("GSFKART", value); } } //lENGth 10
                 public string GSFRBST { get { if (dwMaster == null) return ""; return dwMaster["GSFRBST"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSFRBST"] = value; OnPropertyChanged("GSFRBST", value); } } //lENGth 2
                 public string GSDISPOKZ { get { if (dwMaster == null) return ""; return dwMaster["GSDISPOKZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSDISPOKZ"] = value; OnPropertyChanged("GSDISPOKZ", value); } } //lENGth 1
                 public string GSPLGRP { get { if (dwMaster == null) return ""; return dwMaster["GSPLGRP"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSPLGRP"] = value; OnPropertyChanged("GSPLGRP", value); } } //lENGth 2
                 public string GSPLANART { get { if (dwMaster == null) return ""; return dwMaster["GSPLANART"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSPLANART"] = value; OnPropertyChanged("GSPLANART", value); } } //lENGth 20
                 public string GSAUFKZ { get { if (dwMaster == null) return ""; return dwMaster["GSAUFKZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSAUFKZ"] = value; OnPropertyChanged("GSAUFKZ", value); } } //lENGth 1
                 public string GSPRODH { get { if (dwMaster == null) return ""; return dwMaster["GSPRODH"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSPRODH"] = value; OnPropertyChanged("GSPRODH", value); } } //lENGth 18
                 public string GSMATKL { get { if (dwMaster == null) return ""; return dwMaster["GSMATKL"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSMATKL"] = value; OnPropertyChanged("GSMATKL", value); } } //lENGth 9
                 public string GSBKLAS { get { if (dwMaster == null) return ""; return dwMaster["GSBKLAS"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSBKLAS"] = value; OnPropertyChanged("GSBKLAS", value); } } //lENGth 4
                 public string GSKTO1 { get { if (dwMaster == null) return ""; return dwMaster["GSKTO1"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSKTO1"] = value; OnPropertyChanged("GSKTO1", value); } } //lENGth 6
                 public string GSMATKTO { get { if (dwMaster == null) return ""; return dwMaster["GSMATKTO"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSMATKTO"] = value; OnPropertyChanged("GSMATKTO", value); } } //lENGth 6
                 public string GSMGKMM { get { if (dwMaster == null) return ""; return dwMaster["GSMGKMM"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSMGKMM"] = value; OnPropertyChanged("GSMGKMM", value); } } //lENGth 8
                 public string GSRAVGRP { get { if (dwMaster == null) return ""; return dwMaster["GSRAVGRP"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSRAVGRP"] = value; OnPropertyChanged("GSRAVGRP", value); } } //lENGth 4
                 public string GSKAZGRP { get { if (dwMaster == null) return ""; return dwMaster["GSKAZGRP"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSKAZGRP"] = value; OnPropertyChanged("GSKAZGRP", value); } } //lENGth 1
                 public string GSPRGRPN1 { get { if (dwMaster == null) return ""; return dwMaster["GSPRGRPN1"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSPRGRPN1"] = value; OnPropertyChanged("GSPRGRPN1", value); } } //lENGth 1
                 public string GSPRGRPN2 { get { if (dwMaster == null) return ""; return dwMaster["GSPRGRPN2"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSPRGRPN2"] = value; OnPropertyChanged("GSPRGRPN2", value); } } //lENGth 1
                 public string GSPRGRPN3 { get { if (dwMaster == null) return ""; return dwMaster["GSPRGRPN3"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSPRGRPN3"] = value; OnPropertyChanged("GSPRGRPN3", value); } } //lENGth 1
                 public string GSKAART { get { if (dwMaster == null) return ""; return dwMaster["GSKAART"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSKAART"] = value; OnPropertyChanged("GSKAART", value); } } //lENGth 20
                 public string GSKAVAR { get { if (dwMaster == null) return ""; return dwMaster["GSKAVAR"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSKAVAR"] = value; OnPropertyChanged("GSKAVAR", value); } } //lENGth 3
                 public string GSKASTD { get { if (dwMaster == null) return ""; return dwMaster["GSKASTD"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSKASTD"] = value; OnPropertyChanged("GSKASTD", value); } } //lENGth 1
                 public double GSVRPR { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSVRPR"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSVRPR"] = value; OnPropertyChanged("GSVRPR", value); } } //lENGth 0
                 public string GSBWPLAN { get { if (dwMaster == null) return ""; return dwMaster["GSBWPLAN"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSBWPLAN"] = value; OnPropertyChanged("GSBWPLAN", value); } } //lENGth 1
                 public double GSZTWAHL { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSZTWAHL"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSZTWAHL"] = value; OnPropertyChanged("GSZTWAHL", value); } } //lENGth 0
                 public double GSVERLUST { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSVERLUST"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSVERLUST"] = value; OnPropertyChanged("GSVERLUST", value); } } //lENGth 0
                 public double GSKALKMG { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSKALKMG"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSKALKMG"] = value; OnPropertyChanged("GSKALKMG", value); } } //lENGth 0
                 public string GSKSACHB { get { if (dwMaster == null) return ""; return dwMaster["GSKSACHB"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSKSACHB"] = value; OnPropertyChanged("GSKSACHB", value); } } //lENGth 8
                 public string GSEKGRP { get { if (dwMaster == null) return ""; return dwMaster["GSEKGRP"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSEKGRP"] = value; OnPropertyChanged("GSEKGRP", value); } } //lENGth 3
                 public string GSBSTME { get { if (dwMaster == null) return ""; return dwMaster["GSBSTME"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSBSTME"] = value; OnPropertyChanged("GSBSTME", value); } } //lENGth 3
                 public string GSVABME { get { if (dwMaster == null) return ""; return dwMaster["GSVABME"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSVABME"] = value; OnPropertyChanged("GSVABME", value); } } //lENGth 1
                 public string GSEKWSL { get { if (dwMaster == null) return ""; return dwMaster["GSEKWSL"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSEKWSL"] = value; OnPropertyChanged("GSEKWSL", value); } } //lENGth 4
                 public string GSFILLER { get { if (dwMaster == null) return ""; return dwMaster["GSFILLER"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSFILLER"] = value; OnPropertyChanged("GSFILLER", value); } } //lENGth 86
        */
        #endregion
    }
}
